﻿/********************************************************************************************************************
* Author:	Christos Polydorou																						*
* Email:	std04237@di.uoa.gr																						*
* Purpose:	This script is used in order to create the stored procedure "usp_user_getemail" that returns the email  *
*			address of the user with the specified username.														*
********************************************************************************************************************/

CREATE PROCEDURE [dbo].[usp_user_getemail]
	@username nvarchar(50) 
AS
	SELECT email
	FROM Users
	WHERE username = @username

RETURN 0